retrive values from two table

[abyinsydney]

greetings fellow citizens
I need a suggestion from you people

i have two table suppose

Table one

column 1 column 2 column 3
name age

Table two
column 1 column
name cardno

my query is i need TO find people whose card number strar with 0423etc

this is the query i have built is this right

select name, age from table one,table two where Table one.name=Table two.name where table two.cardnumber like0423 %/


Is this the right query or some suggestions please help

aby

 

[sedj]

like '0423%'

will be fine ...

 

[LFI]

More like this:

select name, age from one, two 
where one.name = two.name 
and two.cardno like '0423%'

No?

--Dave