Hi, I'm curious if I can use "Left Join" together with "group by" as shown below SELECT tbl_data.d1, tbl_customers.c1 FROM tbl_data LEFT JOIN tbl_customers ON tbl_data.d1 = tbl_customers.d1 group by tbl_data.d1, tbl_customers.c1; or is this the way to go? Select DISTINCT(tbl_data.d1), tbl_customers.c1 FROM tbl_data LEFT JOIN tbl_customers ON tbl_data.d1 = tbl_customers.d1; None of these is working, any suggestions?? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
