Обсуждение: Query design

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?