I am not sure whether you have checked for case sensitive issues but it could be that?
document_fields.id,document_fields_link.id are you getting any errors? Andrew >SELECT DF.id, DFL.id >FROM document_fields AS DF LEFT JOIN document_fields_link AS DFL on DF.id = >DFL.document_field_id >WHERE DFL.document_id = 37 >AND DF.is_generic = 1 >-----Original Message----- >From: Rob [mailto:[EMAIL PROTECTED] >Sent: 28 February 2003 12:33 >To: [EMAIL PROTECTED] >Subject: left outer join > > >Could someone please tell me what I'm doing wrong here? > >I have the following two tables > >a)document_fields > >+----+-----------+-----------+------------+------------+ >| id | name | data_type | is_generic | has_lookup | >+----+-----------+-----------+------------+------------+ >| 1 | Category | String | 1 | NULL | >| 2 | Keywords | String | 1 | NULL | >| 3 | Comments | String | 0 | NULL | >| 4 | Author(s) | String | 0 | NULL | >+----+-----------+-----------+------------+------------+ > >b)document_fields_link > >+----+-------------+-------------------+-----------+ >| id | document_id | document_field_id | value | >+----+-------------+-------------------+-----------+ >| 57 | 37 | 3 | | >| 58 | 37 | 4 | jklhkljmh | >+----+-------------+-------------------+-----------+ > >I'm running the following query > >SELECT DF.id, DFL.id >FROM document_fields AS DF LEFT JOIN document_fields_link AS DFL on DF.id = >DFL.document_field_id >WHERE DFL.document_id = 37 >AND DF.is_generic = 1 > >Basically what I want to achieve is this. I want to select all the document >fields that are >generic and IF the document has values for those fields I want to see those >to, otherwise >I want to see null values? > >I thought a left outer join worked as follows: Select all items on the left >table (document_fields) >and join them to all items on the right table (document_fields_link) for >corresponding values >exists, otherwise insert null. > >So I should always get all the values in the document_fields table and >sometimes values in the >document_fields_link table. > >But I don't get any results back. > >Any ideas? > > > >--- >Rob > >************************** >Rob Cherry >mailto:[EMAIL PROTECTED] >+27 21 447 7440 >Jam Warehouse RSA >Smart Business Innovation >http://www.jamwarehouse.com >************************** > > > >--------------------------------------------------------------------- >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 > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 > --------------------------------------------------------------------- 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
