Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 5th, 2013, 12:10 AM
Registered User
Join Date: Jun 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to convert name field into record

I have two tables

1. table 2011_nilai: nama,kode_training,n1,n2,n3,n4
2. table 2011_diklat_materi: kode_diklat,no_urut,judul_diklat
Relation with kode_training=30-03-1 and kode_diklat=30-03.

Example data from 2011_nilai

nama kode_training n1 n2 n3 n4
xx 30-03-01 5 6 6 7
aa 30-03-01 7 7 7 7
Data from 2011_diklat_materi

kode_diklat no_urut Judul_materi
30-03 1 biology
30-03 2 mathematic
30-03 3 Physic
30-03 4 chemistry

I want to perform a MySQL query to return results like this:
nilai Judul_materi
N1 biology
N2 mathematic
N3 Physic
N4 chemistry

Last edited by yanuar1087; June 5th, 2013 at 12:12 AM.. Reason: false

Similar Threads
Thread Thread Starter Forum Replies Last Post
convert time field to number jobalistic Access 17 February 22nd, 2013 12:40 PM
Copy previous field record if next field is null ecampos Access VBA 6 June 23rd, 2006 12:55 PM
String Type Statement to convert field CORiverRat Access 5 December 15th, 2005 02:13 AM
How do you display first record of a field only saf01 Crystal Reports 1 November 7th, 2005 07:49 AM
Empty record field, No image dstubblefield Dreamweaver (all versions) 6 September 3rd, 2004 01:05 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.