I have two tables, the first one has one column as a reference to the index of the second. Not every row in the first table has a reference to the second table. I now want to make a query to get all information of the first table and, if there is a reference, the corresponding information of the second table in that row. In another programming language I would just make an if-clause but how can I do this in SQL?
Thanks for your help
pgsql-sql by date
|Next:||From: Graham Vickrage||Date: 2000-04-19 11:47:03|
|Subject: Query Times|
|Previous:||From: Manuel Lemos||Date: 2000-04-19 07:47:06|
|Subject: Re: Connecting website with SQL-database.....|