Syntax in SQL union

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ngaisteve1 Members Profile Find Members Posts Groupie Joined: 26 December 2002 Location: Malaysia Status: Offline Points: 169	Post Options Post Reply Quote ngaisteve1 Report Post Thanks(0) Quote Reply Topic: Syntax in SQL union Posted: 26 October 2003 at 6:39pm
	I think this question must be very simple for you guys but I just couldn't figure what wrong here. sql = "Select * FROM maple WHERE type = '%"& strType &"%' UNION select * from asli WHERE type = '%"& strType &"%' order by date DESC " Both maple and asli have type field. Thanks.

pmormr Members Profile Find Members Posts Senior Member Joined: 06 January 2003 Location: United States Status: Offline Points: 1479	Post Options Post Reply Quote pmormr Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 7:12pm
	why are you using the modulus character (%) in your statement?
	Paul A Morgan http://www.pmorganphoto.com/

ngaisteve1 Members Profile Find Members Posts Groupie Joined: 26 December 2002 Location: Malaysia Status: Offline Points: 169	Post Options Post Reply Quote ngaisteve1 Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 7:25pm
	I'm using ms access. That's wildcard.

pmormr Members Profile Find Members Posts Senior Member Joined: 06 January 2003 Location: United States Status: Offline Points: 1479	Post Options Post Reply Quote pmormr Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 7:33pm
	you can't use a wild card in an equals statement. it's only valid when you use the 'LIKE' keyword.
	Paul A Morgan http://www.pmorganphoto.com/

ngaisteve1 Members Profile Find Members Posts Groupie Joined: 26 December 2002 Location: Malaysia Status: Offline Points: 169	Post Options Post Reply Quote ngaisteve1 Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 7:57pm
	Oh, yes. I will try to change it. Thanks.

ngaisteve1 Members Profile Find Members Posts Groupie Joined: 26 December 2002 Location: Malaysia Status: Offline Points: 169	Post Options Post Reply Quote ngaisteve1 Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 8:25pm
	Yes. You r right. Now, it works. Thanks.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.