CREATE TABLE `wuensche` (
  `user_id` int(11) NOT NULL default '0',
  `wunsch1` varchar(255) default NULL,
  `wunsch2` varchar(255) default NULL,
  `wunsch3` varchar(255) default NULL,
  `wunsch4` varchar(255) default NULL,
  `wunsch5` varchar(255) default NULL,
  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

SELECT * FROM wuensche WHERE user_id = 1

package JM::Database::Schema::Candidate::CV::DesiredJobs::UnionWithCV;
use base qw/DBIx::Class/;

use strict;
use warnings;
use vars qw/$VERSION/;
$VERSION = '0.01';

our %Columns = (    
    %JM::Database::Schema::Candidate::CV::Columns,
    job_title => {},
);

my $Sql = qq~(
    SELECT cv.*, dj1.job_title1 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj1 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj1.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj2.job_title2 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj2 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj2.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj3.job_title3 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj3 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj3.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj4.job_title4 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj4 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj4.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj5.job_title5 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj5 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj5.cv_id) WHERE cv.completed = 'Y'
)~;

__PACKAGE__->load_components(qw/EncodeColumns Core/);
__PACKAGE__->table( 'dummy_desired_jobs_unionwithcv' );
__PACKAGE__->decode_columns( 'latin-1' );
__PACKAGE__->encode_columns( 'utf-8' );
__PACKAGE__->add_columns(%Columns);
__PACKAGE__->result_source_instance->name( \$Sql );
__PACKAGE__->belongs_to( candidate => 'JM::Database::Schema::Candidate', 'candidate_id' );

1;