我正在使用 database. 我有一个选择问题:
select userid, name, age from tbluser;
现在还有另一个表格,即<代码>tblcalcuatedtax,该表格在传单上产生,其栏目名称未经预先界定,该表与本表之间的唯一绘图是userid。 我在加入两张表格后想获得记录。 我如何能够做到这一点?
简单:
SELECT *
FROM tbluser
JOIN tblcalculatedtax USING (userid)
http://www.postgresql.org/docs/ 当前/interactive/sql-select.html” rel=“nofollow”>manual about SlectT。
页: 1 http://www.w3schools.com/sql/sql_join.asp“rel=“nofollow”http://www.w3schools.com/sql/sql_join.asp。
迅速回答你的问题,但:
SELECT * FROM tbluser
INNER JOIN tblcalculatedtax
ON tbluser.userid=tblcalculatedtext.userid
页: 1 当然,我不敢肯定,如果你不知道哪一栏,你会知道它包含哪些数据?
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...