Toymods Car Club Inc: The Outhouse => HELP! SQL Query for Uni...

Toymods Car Club
www.toymods.org.au

F.A.Q.

Home

Members

Toymods » The Outhouse » HELP! SQL Query for Uni... Show: Today's Posts :: Show Polls Email to friend

Author

Topic

SupraPete
Forums Junkie

Location:
Sydney
Registered:
July 2002

Re: HELP! SQL Query for Uni...

Thu, 30 October 2003 05:53

ehendrikd wrote on Tue, 28 October 2003 17:06

select repairlog.*, technicians.chargeperhour from technicians, (select * from pcdetails, repairlog where pcdetails.pc_id = repairlog.pc_id) where technicians.technicians_id = repairlog.technicians_id

You didn't format it nicely Mad

I don't think you need another select though (and why are you selecting *?), your not assigning the values to anything.

I think the whole inner statement is in the wrong spot. I think it should be after the where clause.

You havn't got a from for repairlog in your first select statement

I don't know what database its written for and don't think it will work.

SQL is relative to the database its to be run on, so your code (and my code) could run on some databases and not on others.

[Report message to a moderator]

[Message index]

-=] Back to Top [=-

Current Time: Sun Dec 22 13:52:03 UTC 2024

Total time taken to generate the page: 0.0068929195404053 seconds

.:: Contact :: Home ::.