Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VALpm-0007LA-6I for pgsql-general@arkaria.postgresql.org; Fri, 16 Aug 2013 15:21:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VALpl-000135-Au for pgsql-general@arkaria.postgresql.org; Fri, 16 Aug 2013 15:21:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAKC8-0002f2-Kb for pgsql-general@postgresql.org; Fri, 16 Aug 2013 13:36:00 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAKC5-0005TL-0l for pgsql-general@postgresql.org; Fri, 16 Aug 2013 13:36:00 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1VAKC3-0000jc-S5 for pgsql-general@postgresql.org; Fri, 16 Aug 2013 06:35:55 -0700 Date: Fri, 16 Aug 2013 06:35:55 -0700 (PDT) From: Basavaraj To: pgsql-general@postgresql.org Message-ID: <1376660155863-5767611.post@n5.nabble.com> In-Reply-To: <1376058047506-5766954.post@n5.nabble.com> References: <1376058047506-5766954.post@n5.nabble.com> Subject: need help MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.0 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org i have two unrelated tables as their is no common column to apply joins or anything, so i want to join those tables using simple query(only two tables should be used and no common table) can you pls help me out how to do that. I am new user to postgres this is table format table1 table2 name| address|email| mobileNo|firstname|lastName| ---------------------- ------------------------------ abc some1 mail1 1234564|def | : : : : : : :5 records 10 records finally the result shoule be name| address|email|mobileNo|firstname|lastName| -------------------------------------------------- abc some1 mail1 1234564 def xyz 5 records | 10 records | Very thankful for solution............ -- View this message in context: http://postgresql.1045698.n5.nabble.com/Here-is-my-problem-tp5766954p5767611.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general