Table Relationships & Query

Results 1 to 3 of 3

Thread: Table Relationships & Query

  1. #1
    Join Date
    Dec 1969

    Default Table Relationships & Query

    I have a form that submits a query and retrieves information about a jobs of select industries. The information is being retrieved correctly (used FP 2002 and the DRW), but I want to have information from another table also come up in the same results page. For example- the employer&#039;s information should be consisten on every job posting, and that information is retreived from an empTable (while jobs are retrieved from jobsTable).<BR><BR>Can&#039;t seem to get it write, even by creating a relationship.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default And did you expect us to

    guess what your table structure was and what relationship were.....<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default simple select

    create the joined field (in the jobs table create a field that represents the employer)<BR>&#039;select e.*, j.* from employertable e, jobstable j where<BR>j.jobID = xx and j.employerID = e.employerID&#039;<BR><BR>this will select all the fields both tables then you just pass the info to the browser.<BR><BR>hth<BR>Bastien

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts