i wish to return many fields from 1 table and 1 field from another

SELECT * FROM Table1 WHERE field = Parameter
SELECT field FROM Table2 WHERE field = Table1.field

this works but only returns records where ImageID has a value.
i need all fields from Table1 regardless.

SELECT Q.*, I.Image FROM Table1 Q, Table2 I
WHERE Q.QuoteNumber = :QuoteNumber
AND Q.ImageID = I.ImageID

Aaron,

You must use an OUTER Join:

SELECT
 Q.*, I.Image
FROM
  Table1 Q
  LEFT OUTER JOIN Table2 I ON Q.ImageID = I.ImageID
WHERE
 Q.QuoteNumber = :QuoteNumber

--
Fernando Dias
[Team Elevate]

Aaron


I think you need a LEFT OUTER JOIN but could well be wrong since I rarely get these right.


SELECT Q.*, I.Image
FROM
Table1 Q
LEFT OUTER JOIN Table2 I
WHERE Q.QuoteNumber = :QuoteNumber
AND Q.ImageID = I.ImageID

Roy Lambert

thanx guys

Fernandos script worked, YAY