Code Forums - View Single Post

sde · 05-25-2006, 08:38 AM

i know you tried to explain it clearly, but i don't completely get it yet.

table1: developer_log
id
company
project
property
email
cc_email

table2: developer
name
project
type

ok, so the 'project' field is the relation between these 2 tables right?

if you wanted all the developer information in each row of the original query, and they were joined on the project, your query might look like this. ( although i'm not sure if this is what you are going for )

Code:

select * from developer_log as dl
  left join developer as d on dl.project=d.project
  where dl.expiry > '$mktime'

05-25-2006, 08:38 AM	#3 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	i know you tried to explain it clearly, but i don't completely get it yet. table1: developer_log id company project property email cc_email table2: developer name project type ok, so the 'project' field is the relation between these 2 tables right? if you wanted all the developer information in each row of the original query, and they were joined on the project, your query might look like this. ( although i'm not sure if this is what you are going for ) Code: select * from developer_log as dl left join developer as d on dl.project=d.project where dl.expiry > '$mktime' __________________ Mike