From: | "R(dot)Stevens" <raimee(at)ij(dot)net> |
---|---|
To: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Query design |
Date: | 1998-08-08 18:27:11 |
Message-ID: | 35CC987F.2B3243FB@ij.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Two Tables:
Blackbook
*********
key = vin char(8) + vinyr char(1) -First field plus Second field
Auction
*******
key = vin[1-8] + vin[10] -First 8 characters plus the
tenth character of first field.
Need to create Join as follows:
Now, the query i've been experimenting goes something like this (but
does NOT work):
Select (A.vin || A.vinyr as BB), ...some other stuff..., (B.vin[1-8]
+B.vin[10]) as SS
>From blackbook A, Sales B
Where A.make = '$Input_from_var' and
A.model = '$Input_form_var' and
BB = SS
The $Input_form_variables are PHP varalbes - Ignore!
Am I using the correct syntax?
From | Date | Subject | |
---|---|---|---|
Next Message | Maarten Boekhold | 1998-08-08 20:51:26 | Re: [GENERAL] Postgres CGI Security Problem |
Previous Message | The Hermit Hacker | 1998-08-08 18:18:26 | Re: [GENERAL] Developers list |