Re: Question on Join

Manoj wrote: Dear All, I am trying to join two tables say a b. Both tables have a set of dates. I want to join the tables in such a fashion that I retrieve all dates from table A. If table b has corresponding data (for that date) then it will display it or else will display null. I am

Question on Join

Dear All, I am trying to join two tables say a b. Both tables have a set of dates. I want to join the tables in such a fashion that I retrieve all dates from table A. If table b has corresponding data (for that date) then it will display it or else will display null. I am pretty sure that I

Question about JOIN behaviour - I can't figure out how it works

Hi. I searched MySQL manual but I stil don't know how a JOIN works. I would like to avoid diging into sources so I'm posting this mail. I have two tables: - a HUGE table having a row ID_keywords - a SMALL table with keywords and columns ID_keywords and keyword_name I have to select some rows

Re: Mysql SELECT question (LEFT JOIN?)

by now, i hope, you've gotten answers from the sql gurus on the list, so i won't clutter with my humble attempts. your comment about problems with joins indicates that corereader might be of some help to you if you have a windows box for a front end. it will let you do quick

re: Mysql SELECT question (LEFT JOIN?)

Eric, Friday, November 15, 2002, 1:36:54 AM, you wrote: EA Assume two tables: EA CREATE TABLE block_ip ( EA datestamp int(11) NOT NULL default '0', EA remote_addr char(15) NOT NULL default '', EA PRIMARY KEY (remote_addr), EA KEY datestamp (datestamp) EA ) TYPE=MyISAM; EA CREATE TABLE

Mysql SELECT question (LEFT JOIN?)

Assume two tables: CREATE TABLE block_ip ( datestamp int(11) NOT NULL default '0', remote_addr char(15) NOT NULL default '', PRIMARY KEY (remote_addr), KEY datestamp (datestamp) ) TYPE=MyISAM; CREATE TABLE brute_force ( datestamp int(11) NOT NULL default '0', remote_addr char(15)

Query question in join table with null

I have been battling with a complex query that us giving me a tremendous headache.. I have a MASTER table with 7 other tables (I can not change the database) The master table contains values (Key's) which I then need to lookup in another table that has 2 fields, the Key and a Description field.

SQL question regarding JOIN

I have two tables, one contains user account info the other contains active sessions in a web app. In the user account table I have a column that contains each user's 'access level'. I'm somewhat new to relational databases and SQL, and though the following is working for me, I want to find out