I'm not sure if this is possible:<BR><BR>Join two tables if the value in the first table is not null, and if it is null, still return a row but with the null value.
Select table1.*, table2.* from <BR>table1 LEFT JOIN table2 on table1.joinfield = table2.joinfield<BR><BR>Or it may be RIGHT JOIN. Never can remember which one does which.<BR><BR>Read up on Left Outer Join & Right Outer Join
LEFT JOIN gets all the rows from the 'first' table in the statement. RIGHT JOIN the rows from the second table.<BR><BR>