User Profile

cripton · Mar 18 '08, 05:33 AM

hope this will help

select a.* , b.*
from table1 a, table2 b
where a.Fcode = b.FCode

------------------------------------------------------------

select * from Table1
where FCode in (select FCode from Table2)...

cripton · Mar 14 '08, 07:56 AM

try to check ur IP addresses if u have the same Format with the pc wih vista...

cripton · Mar 14 '08, 06:33 AM

try this...
if they are sort by name try this syntax

Name
Address
Phone
Email

select top 1 * from TABLE order by Name Desc

hope this will help

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment: