F.A.Q.    Register    Login    Home Members    Search

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

Author	Topic
ZZT231 Forums Junkie I Supported Toymods Location: melbourne.vic.au Registered: May 2002	HELP! SQL Query for Uni... Tue, 28 October 2003 03:24 Hey All, My teacher said that I could not use MS Access as my Query Generator and I have to use my brain Query is: SELECT RepairLog.*, Techicians.chargeperhour FROM Techicians INNER JOIN (PCDetails INNER JOIN RepairLog ON PCDetails.pc_id = RepairLog.pc_id) ON Techicians.techicians_id = RepairLog.techicians_id Can anyone be able to convert it to standard SQL (Without mentioning Inner Join)? Cheers. [Report message to a moderator]

	Subject	Poster	Date
	HELP! SQL Query for Uni...	ZZT231	Tue, 28 October 2003 03:24
	Re: HELP! SQL Query for Uni...	ehendrikd	Tue, 28 October 2003 06:06
	Re: HELP! SQL Query for Uni...	SupraPete	Thu, 30 October 2003 05:53
	Re: HELP! SQL Query for Uni...	Nark	Tue, 28 October 2003 09:40
	Re: HELP! SQL Query for Uni...	ZZT231	Tue, 28 October 2003 21:35
	Re: HELP! SQL Query for Uni...	ZZT231	Tue, 28 October 2003 21:38
	Re: HELP! SQL Query for Uni...	SupraPete	Tue, 28 October 2003 23:55
	Re: HELP! SQL Query for Uni...	ZZT231	Wed, 29 October 2003 06:14
	Re: HELP! SQL Query for Uni...	SupraPete	Wed, 29 October 2003 06:45
	Re: HELP! SQL Query for Uni...	gtman	Thu, 30 October 2003 02:41
	Re: HELP! SQL Query for Uni...	SupraPete	Thu, 30 October 2003 02:49
	Re: HELP! SQL Query for Uni...	ehendrikd	Thu, 30 October 2003 05:32

Previous Topic:	Who went to the ministry of sound tour
Next Topic:	Rugby World Cup

Powered by: FUDforum 2.3.8
Copyright ©2001-2003 Advanced Internet Designs Inc.