Thats DBIx::Class question and not a catalyst question.<br>here are dbix class docs: <a href="http://search.cpan.org/~frew/DBIx-Class-0.08124/">http://search.cpan.org/~frew/DBIx-Class-0.08124/</a> everything you need is there. Take a look at joining at the bottom of the page.<br>
<br>--Hernan<br><br><div class="gmail_quote">On Tue, Dec 14, 2010 at 1:27 PM, Vivek Chhikara <span dir="ltr"><<a href="mailto:vivek@chhikara.org">vivek@chhikara.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<p><br><br>I am new to catalyst and need guidance in fetching some data from my mysql db.<br><br>I want to know how can I write below queries(1&2)<br><br><span style="color: rgb(0, 0, 255);">Here is dummy table structure I am using. </span><br>
<span style="color: rgb(0, 0, 255);">-------------------------------------------------</span><br><span style="color: rgb(0, 0, 255);"> table1</span><br><span style="color: rgb(0, 0, 255);"> =======</span><br>
<span style="color: rgb(0, 0, 255);"> qid sid status name</span><br><span style="color: rgb(0, 0, 255);"> __PACKAGE__->set_primary_key("qid");</span><br><span style="color: rgb(0, 0, 255);"> __PACKAGE__->belongs_to("queq_dump", 'MYAPP::Schema::Result::Table2, {qid => 'qid'});</span><br>
<br><span style="color: rgb(0, 0, 255);">-------------------------------------------------</span><br><span style="color: rgb(0, 0, 255);"> table2</span><br><span style="color: rgb(0, 0, 255);"> pid eid qid name</span><br>
primary_key == pid+qid+eid<br><span style="color: rgb(0, 0, 255);">-------------------------------------------------</span><br><br><span style="color: rgb(51, 153, 102);"> QUERY 1</span><br><span style="color: rgb(51, 153, 102);"> =======</span><br>
<span style="color: rgb(51, 153, 102);"> select A.qid, A.name, A.name from table1 A, table2 B </span><br><span style="color: rgb(51, 153, 102);"> where </span><br><span style="color: rgb(51, 153, 102);"> A.qid = B.qid </span><br>
<span style="color: rgb(51, 153, 102);"> and A.sid = 1</span><br><span style="color: rgb(51, 153, 102);"> and B.pid != 2</span><br><br><span style="color: rgb(51, 153, 102);"> QUERY 2</span><br><span style="color: rgb(51, 153, 102);"> =======</span><br>
<span style="color: rgb(51, 153, 102);"> select A.qid, A.name, A.name from table1 A, table2 B </span><br><span style="color: rgb(51, 153, 102);"> where </span><br><span style="color: rgb(51, 153, 102);"> A.qid = B.qid and B.eid = (select min(eid) from table2 where table2.status = 1)</span></p>
<br>_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
<br></blockquote></div><br>