combining these 2 queries

[roach]

Howdy

Is there anyway I can combine these 2 queries into just 1 query
using postgres?
Im having problems keeping names in a constant order with 2 queries...

$query1 = "SELECT * from mod_sced where date='$start1';";

$query2 = "SELECT mod_sced.id, mod_sced.date, sced.name, sced.sun, sced.mon, sced.tue, sced.wed, sced.thur, sced.fri, sced.sat FROM sced
LEFT JOIN mod_sced ON sced.name = mod_sced.name and mod_sced.date='$start1'
WHERE mod_sced.name IS NULL order by name;";

thanks!

[ultraslacker]

You have an extra semicolon in your queries - you do not need to terminate a query with a semicolon in PHP.

SELECT m.*,sced.name, sced.sun, sced.mon, sced.tue, sced.wed, sced.thur, sced.fri, sced.sat
FROM sced
LEFT JOIN mod_sced m
ON (sced.name = m.name AND m.date = '$start1')
ORDER BY name