Question #11700191

Help with SQL UNION Query.?

SELECT * FROM xbox360 UNION ALL SELECT * FROM playstationthree WHERE GamePrice >= 1 AND GameAgeRating='15' LIMIT 10 The code is part of a products page and if the user specifies which table to browse IE without the UNISON code the query is fine at selecting the age and displaying only games that have that age but with unison applied and the table not specified it just displays everything. Any help appreciated.

2013-11-10 18:57:41

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The helpinganswers.com is a free-to-use knowledgebase.
  The helpinganswers.com was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters

  Contact: support@helpinganswers.com

C'mon... follow us!

Made by, history, ect.