Criteria sytnx

[LELOA]

Query and a data table. What I need to do is compare part number + neda two separate colums in both tables when table matches with query returns a value of another colum from the data table. is that possbile

Lee

 

[lespaul]

hard to know what you are trying to do from your post, could you explain a little more?

 

[LELOA]

two tables

no unique id
need to combine two columns to make unique id
to be able to pull one table into the other

How would I do this without reloading tables


lee

 

[nicsin]

Still unclear. What do you mean reloading tables? Are the two fields present in the other table as foreign keys? If yes then:

table1 inner join table2 on (table1.field1 = table2.field1 and table1.field2 = table2.field2)

Is that what you were looking for?

 

[lespaul]

Ok, so you have two tables with columns. Neither table has a primary key. You want to combine the two tables into one and at the same time combine two columns into one to make a primary key field?

Perhaps if you give us the table structure, some field names maybe, and a few more details about what you are doing, we could help.