Member Avatar for veledrom

Hi,
I have 2 tables "name1_" and "name_2". I want to compare them.
If name in "name_1" table is same as name in "name_2" table, then copy whole row into other table "name_3".

Thanks

  • 2 Contributors
  • 1 Reply
  • 47 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by varmadba
Member Avatar for varmadba

Try this...

if name_3 table is not yet created

create table name_3
as
select name_1.* from name_1
inner join name_2
  on name_1.name=name_2.name

if name_3 table is already created

insert into name_3
select name_1.* from name_1
inner join name_2
  on name_1.name=name_2.name
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.