select like - table left join

Jul 3, 2012 at 7:22 AM

Hi

i have 2 questions:

1) How can i do query like this "select * from mid_Companies where name like '%Informatic%' "

2) How can i do join between tables, ex:

select * from mid_Welds W

LEFT JOIN mid_Isometrics I ON W.ID_Isometric = I.IsometricID

 

PS Your project has no documentation!!! but it's very interesting...