Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Query to join two tables in SQL
Top Forums Programming Query to join two tables in SQL Post 302549404 by vanitham on Tuesday 23rd of August 2011 02:49:20 AM
Old 08-23-2011
Query to join two tables in SQL
Hi,

I have 2 tables.

Code:
Table1

name  map_code    data_code        id
aaa	 2732C	   3333B		10
bbb    1223F	   2545v		11
ccc  				  	        12


Code:
Table2

 
name   map_code   data_code        id    text_description
aaa	  2732C	   3333B		10    description 1
bbb     1223F	   2545v		11    description 2 
ccc  				 	        12    description 3

I want to perform join on these 2 tables. The column to be used to join is map_code & data_code.

The map_code & data_code are null for the id: 13 name: ccc


The output should be like this:
Code:
name   map_code   data_code   id 	  text_description
aaa      2732C       3333B         10	     description 1
bbb	  1223F        2545v         11       description 2 
ccc  	  				   12       description 3

How to get the above output?

Regards
Vanitha
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tables to query to find users for database from shell script

I am coding shell script. I need to connect to different databases like DB2, Oracle and Sybase. I would then need to query tables where it has all the groups, users for that database. I would also need who has what kind of permissions. EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies

2. Programming

SQL Add to Multiple Tables

I'm pretty new to the database world and I've run into a mental block of sorts. I've been unable to find the answer anywhere. Here's my problem: I have several tables and everything is as normalized as possible (as I've been lead to understand normalization.) Normalization has lead to some... (1 Reply)
Discussion started by: flakblas
1 Replies

3. Programming

sql,multiple join,outer join issue

example sql: select a.a1,b.b1,c.c1,d.d1,e.e1 from a left outer join b on a.x=b.x left outer join c on b.y=c.y left outer join d on d.z=a.z inner join a.t=e.t I know how single outer or inner join works in sql. But I don't really understand when there are multiple of them. can... (0 Replies)
Discussion started by: robbiezr
0 Replies

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

5. Programming

MySQL join four tables!

Hello; I want merge four MySQL tables to get the intersection that have a common field for all of them. Join two tables is fine to me, but my this case is different from common situations and there are not very many discussions about it. Can anybody give me some idea? Thanks a lot! Here is part... (8 Replies)
Discussion started by: yifangt
8 Replies

6. Programming

Dynamically checking rules in database tables using SQL

I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5. I plan to do this mechanically, so the approach should work for any table in my database schema. Suppose for illustration purposes I start with the following table: CREATE TABLE `sources` ( ... (4 Replies)
Discussion started by: figaro
4 Replies

7. Shell Programming and Scripting

Call and execute query from tables

Hi.. We have a table DB_QUERIES, in which sql queries are stored. SQL> desc DB_QUERIES Name Null? Type ----------------------------------------- -------- ---------------------------- QUERY_ID NOT NULL NUMBER(10) ... (2 Replies)
Discussion started by: sameermohite
2 Replies

8. Shell Programming and Scripting

Shell script automation using cron which query's MySQL Tables

What I have: I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory) note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies

9. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies

10. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies

LEARN ABOUT OSF1

displayofccc

DisplayOfCCC(3X11)														DisplayOfCCC(3X11)

NAME

       DisplayOfCCC, VisualOfCCC, ScreenNumberOfCCC, ScreenWhitePointOfCCC, ClientWhitePointOfCCC - Color Conversion Context macros

SYNOPSIS

       DisplayOfCCC(ccc)
	       XcmsCCC ccc;

       VisualOfCCC(ccc)
	       XcmsCCC ccc;

       ScreenNumberOfCCC(ccc)
	       XcmsCCC ccc;

       ScreenWhitePointOfCCC(ccc)
	       XcmsCCC ccc;

       ClientWhitePointOfCCC(ccc)
	       XcmsCCC ccc;

ARGUMENTS

       Specifies the CCC.

DESCRIPTION

       The DisplayOfCCC macro returns the display associated with the specified CCC.

       The VisualOfCCC macro returns the visual associated with the specified CCC.

       The ScreenNumberOfCCC macro returns the number of the screen associated with the specified CCC.

       The ScreenWhitePointOfCCC macro returns the screen white point of the screen associated with the specified CCC.

       The ClientWhitePointOfCC macro returns the client white point of the screen associated with the specified CCC.

SEE ALSO

       XcmsCCCofColormap(3X11), XcmsConvertColors(3X11), XcmsCreateCCC(3X11), XcmsDefaultCCC(3X11), XcmsSetWhitePoint(3X11)

       Xlib -- C Language X Interface

																DisplayOfCCC(3X11)
All times are GMT -4. The time now is 08:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy