cross table queries in SQL 4.0 On-line

Posted in 1991

Walt Hultgren {rmy} — Sun, 6 Oct 91 13:35:12 -0400 — source: Informix-list mailing list archive (1991-1998)

Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!mtrotter From: mtrotter@magnus.acs.ohio-state.edu (Mark L Trotter) Newsgroups: comp.databases.informix Message-ID: <1991Oct4.130134.10286@magnus.acs.ohio-state.edu> Date: 4 Oct 91 13:01:34 GMT Sender: news@magnus.acs.ohio-state.edu Organization: The Ohio State University Nntp-Posting-Host: top.magnus.acs.ohio-state.edu I am trying to find a way to do cross table querys and haven't had much luck. Here is the scenario: two tables: names containing names and address, and sales containg items bought. I want to do a query in the table names for all folks that live in a particular city (names table) and purchased a particular item (sales table). I am on an HP9000/800 running the On-line engine using SQL v4.0. Any help will be appreciated. Thanks, Mark Trotter (trotter.1@osu.edu)