Joining a set of numbers

[serino]

I have two queries. First query is called Prefix and the second called Lot Numbers. Prefix contains a field that produces a set of numbers e.g 40214. Lot Number contains a field that also produces a set of numbers e.g 32.


How would join these two numbers in a new query and have a field display 4021432?

 

[lespaul]

is there a common field between the two queries? If so something like:

SELECT PrefixQuery.FieldName & LotNumberQuery.FieldName As CombinedNumber From PrefixQuery INNER JOIN LotNumberQuery On PrefixQuery.CommonFIeld = LotNumberQuery.CommonField

Are the fields text fields or number fields?

if there is no common field to join on maybe a cartesian join would work:

SELECT PrefixQuery.FieldName & LotNumberQuery.FieldName As CombinedNumber From PrefixQuery, LotNumberQuery


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[serino]

Thank You Leslie. The cartesian join worked great!!