joining tables

Recommended Answers

All 5 Replies

!!Combining 2 tables!!

CREATE TABLE details (
atm_sno int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  
  pickmodule varchar(20) NOT NULL,

pickmodulemanuf varchar(20) NOT NULL,

  cardreader varchar(20) NOT NULL,

cardreadermanuf varchar(20) NOT NULL,

  printer varchar(20) NOT NULL,

printermanuf varchar(20) NOT NULL,
   
  bank char(20) NOT NULL,

  location char(20) NOT NULL,

  engname char(20) NOT NULL,

date DATE NOT NULL

) type=MyISAM;
CREATE TABLE defect (
atm_sno int(15) NOT NULL,
  
  pickmodule varchar(50) NOT NULL,

pickmodulemanuf varchar(50) NOT NULL,

  cardreader varchar(50) NOT NULL,

cardreadermanuf varchar(50) NOT NULL,

  printer varchar(50) NOT NULL,

printermanuf varchar(50) NOT NULL

) type=MyISAM;

In the second table there is no entry for date so i should use the date from 1st table

select printermanuf, count(*) from details where date >='$entername1' and date <='$entername2' group by printermanuf;

How to change this query to get results from both the table

select printermanuf, count(*) from details where date >='$entername1' and date <='$entername2' group by printermanuf
select pickmodulemanuf, count(*) from defect group by pickmodulemanuf

How to join these to get the single result!!!

select printermanuf, count(*) from details where date >='$entername1' and date <='$entername2' group by printermanuf
select pickmodulemanuf, count(*) from defect group by printermanuf

How to join these to get the single result!!!

select printermanuf, count(*) from details where date >='$entername1' and date <='$entername2' group by printermanuf
select pickmodulemanuf, count(*) from defect group by printermanuf

How to join these to get the single result!!

Member Avatar for diafol

How to join these to get the single result!!

You schizophrenic or what? You keep having these one-way conversations. Is this your last post or is there any more info to come?
Please formulate your question in full before you post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.