Query syntax.

2003-12-22 Thread Data Boy
Hi, I'm having problems with the syntax of a select statement. I have two tables linked together by account number. The first table (Users) looks similar to this |User_Account | User_Name | User_Address |X10010100110 | Michael Smith | 1000 North Main St |X10010100240 | David Wils

Re: Query syntax.

2003-12-23 Thread Data Boy
WHERE a.User_Account = b.Device_Account > AND b.Device_Name LIKE 'HP%' - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Will Lowe" <[EMAIL PROTECTED]> Cc: "Data Boy" <[EMAIL PROTECTED]>; <[EMAIL

Query help for fields with continuation columns

2004-02-07 Thread Data Boy
Hi, I've some data out of a legacy application which has a list of names and mailing addresses for contacts. The legacy data is from a DG database. Every few weeks my sql database will be repopulated. There are four varchar(30) fields describing names and addresses (name1,add1,add2, add3