Is this wrong?

Shamrox

I have a feeling I wrote this wrong. Maybe I need to use joins? My output doesn't seem right. Help appreciated.

SELECT employees.name, ids_oa.oa_name, ids_requisition.wcfoffice, ids_requisition.acid, ids_requisition.req_number, ids_requisition.complete_hrs, ids_worktype.worktype, ids_requisition.date, ids_ostoffice.ost_office
FROM employees, ids_requisition, ids_oa, ids_worktype, ids_ostoffice
WHERE ids_requisition.date >= 'startdate' AND ids_requisition.date <= 'enddate'  AND employees.eid= 'analyst'  AND employees.eid=ids_requisition.eid AND ids_oa.oaid=ids_requisition.oaid AND ids_requisition.work_type=ids_worktype.wid
ORDER BY ids_oa.oa_name

stolzyboy

would be a little more helpful if you would let us know WHAT you want it to do

bike5

I have a feeling I wrote this wrong. Maybe I need to use joins? My output doesn't seem right. Help appreciated.

It the output is not correct, then yes the answer is that it is wrong 😉

Give more details..

Shamrox

The main table ids_requisition holds all the main data, with IDs stored that link to the other tables.
For my output I need to display the data for a record in the ids_requisition table, but also display the "name" that relates to those linked ID's in the other tables. Hence why i used the id=id references in the WHERE section. But...my output replicates the records over and over. Making me think that my syntax is not correct and that I should be using joins. But, I spent some time reading up on Joins from the mysql doc and that doesn't seem right either.

i hope this is enough info to confuse us all less. LOL. thanks for the help.

kakki

what join argument do you do for "ids_ostoffice" ....
like ids_ostoffice.id = sth.ostoffice_id

Shamrox

I see I omitted that, thanks. But, it's still not returning all the correct data.

Added this: ids_ostoffice.ostid=ids_requisition.oid