Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ZggZg

  1. ZggZg

    problem with JOINS

    Thanks Lespaul. In this case the union works perfect! Cheers ZggZg
  2. ZggZg

    problem with JOINS

    Hi Mike, But how does that go in one query?
  3. ZggZg

    problem with JOINS

    Hi there, I'm going nuts over an SQL JOIN statement and after trying everything I hope somebody can hint me on this one: Let's say I got the tables comp, cities, countries and the related fields comp.formal_address = cities.city_id comp.informal_address = cities.city_id comp.country_id =...
  4. ZggZg

    query and join two tables on two other tables

    Hi DanChard, What I'm after is combine both tables to one output. ColdFusion5+ has a Query of queries feature. I'm now trying to combine two queries into this one query of queries, which should be possible (at least it is in ColdFusionMX): query1: select fields from table1 query2: select fields...
  5. ZggZg

    query and join two tables on two other tables

    Hi Guys, the problem doesn't have to do with the wildcards because '%#x#' works fine. The second query is more a refinement on the first so it's not that both are used at the same time.
  6. ZggZg

    query and join two tables on two other tables

    Hi, I've two tables, priv and bedr. I need to find all values for parameter 'x' in fields priv.priv_name, bedr.bedr_name, bedr.bez_name, bedr.verv_name in one query. The table priv contains a foreign key (priv_x_bedr_id) to bedr.bedr_id. SELECT * FROM priv, bedr WHERE priv.priv_name LIKE...
See more

Part and Inventory Search

Back
Top