Recent content by Bene1

Thanks... this is exactly what I wanted!!!!

I have two SQL tables that hold zipcode info. One is for US and one is for Canada. I am working on a stored procedure that has a parameter @city, and then returns the City, State, and Zip from each table WHERE (City = @city). I can get it working for one table or the other, but not both...

Thanks both of you. I got it working now...

I am trying to assign a value to a variable based on the results of a view. For example, if the value of a column comes back as NULL then I want my variable to equal 0. If the column returns something other than NULL, then I want the variable to be assigned a 1. Is this even possible within...

Yes... the second suggestion worked perfectly. Thank you very much. I did not know that you could JOIN to a sub-query like that. Most useful...

Here is the code SELECT groups.*, user_access.user_name FROM groups LEFT OUTER JOIN user_access ON user_access.group_name = groups.name Except that this does not restrict by user_name. When I try to restrict it by user_name, then I lose the ability to view all of the records held in...

I have been working on this for a while now, and I am getting very frustrated. Hopefully someone out there will be able to help... I have two tables that I am linking together. I need to see all records out of the table 'GROUPS' and in another filed I need to see 'USER_NAME' from...