I have two tables.
First holds the singe row information to be displayed.
JobID - Company - Site - Contact
11 - ASB - site1- gazz
22 - HSA - site2 - Joe
Second can either have one or more rows based on the filter from the first table.
JobID - first name - surname
11 - Greg - Potter
11 - Frank - Harrys
22 - Dom - Davies
What I would like to happen is this:
JobID - Company - Site - Contact - Engineer
11 - ASB - site1 - gazz - Greg Potter - Frank Harrys
22 - HSA - site2 - Joe - Dom Davies
Can this be done?
I'm pulling this from SQP 2008 and using it in ASP so really need it as a view or something like that as this to be pulled via a Recordset.